package com.mav01.mrpbackend.mapper;

import com.mav01.mrpbackend.pojo.Material;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

// 物料相关Mapper
@Mapper
public interface MaterialMapper {

    @Select("SELECT * FROM Material WHERE material_no = #{materialNo}")
    Material selectByMaterialNo(String materialNo);

    @Select("SELECT * FROM Material WHERE allocation_method = '生产'")
    List<Material> selectProductNames();
}
